from applications.extensions import db


class JyxtNotice(db.Model):
    """
    交易系统公告信息表
    """
    __tablename__ = 'jyxt_notice'  # 设置表名, 表名默认为类名小写
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 设置主键, 默认自增
    ZYLB = db.Column(db.String(64))
    XZQBM = db.Column(db.String(64))
    GGBH = db.Column(db.String(64))
    GGLB = db.Column(db.String(64))
    GGFBSJ = db.Column(db.String(64))
    GGID = db.Column(db.String(64))
    ZYS = db.Column(db.String(64))
    JYFS = db.Column(db.String(64))
    GGMC = db.Column(db.String(64))
    FBR = db.Column(db.String(64))
    JYLB = db.Column(db.String(64))
    GSFJ = db.Column(db.String(64))
    XZQMC = db.Column(db.String(64))
    TZFJ = db.Column(db.String(64))
    sfts = db.Column(db.String(64), default=0)
    url = db.Column(db.String(256))
